package com.dy.placeOrder.mapper;

import org.apache.ibatis.annotations.Select;
import com.dy.placeOrder.ConfirmOrder;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author author
 * @since 2024-11-21
 */
public interface ConfirmOrderMapper extends BaseMapper<ConfirmOrder> {

    @Select("<script>" +
            "SELECT c.*,o.name oname FROM confirm_order c left join orders o ON c.oid=o.id WHERE c.id = #{id}" +
            "</script>")
    List<ConfirmOrder> findById(Integer id);



}
